{
  "statement":"SELECT * FROM v11",
  "table_meta":{
    "v0.t0":"CREATE TABLE `t0` (\n  `c_0_0` date NOT NULL COMMENT \"\",\n  `c_0_1` datetime NOT NULL COMMENT \"\",\n  `c_0_2` boolean NOT NULL COMMENT \"\",\n  `c_0_3` boolean NOT NULL COMMENT \"\",\n  `c_0_4` boolean NOT NULL COMMENT \"\",\n  `c_0_5` int(11) NOT NULL COMMENT \"\",\n  `c_0_6` float NOT NULL COMMENT \"\",\n  `c_0_7` ARRAY\u003cint(11)\u003e NOT NULL COMMENT \"\",\n  `c_0_8` ARRAY\u003cint(11)\u003e NOT NULL COMMENT \"\",\n  `c_0_9` largeint(40) NOT NULL COMMENT \"\",\n  `c_0_10` ARRAY\u003cint(11)\u003e NOT NULL COMMENT \"\",\n  `c_0_11` varchar(11) NOT NULL COMMENT \"\",\n  INDEX index1_c_0_2 (`c_0_2`) USING BITMAP\n) ENGINE\u003dOLAP \nPRIMARY KEY(`c_0_0`, `c_0_1`, `c_0_2`, `c_0_3`, `c_0_4`, `c_0_5`)\nCOMMENT \"OLAP\"\nPARTITION BY RANGE(`c_0_0`)\n(PARTITION p20100101 VALUES [(\u00272010-01-01\u0027), (\u00272010-04-06\u0027)),\nPARTITION p20100406 VALUES [(\u00272010-04-06\u0027), (\u00272010-07-10\u0027)),\nPARTITION p20100710 VALUES [(\u00272010-07-10\u0027), (\u00272010-10-13\u0027)),\nPARTITION p20101013 VALUES [(\u00272010-10-13\u0027), (\u00272011-01-16\u0027)),\nPARTITION p20110116 VALUES [(\u00272011-01-16\u0027), (\u00272011-04-21\u0027)),\nPARTITION p20110421 VALUES [(\u00272011-04-21\u0027), (\u00272011-07-25\u0027)),\nPARTITION p20110725 VALUES [(\u00272011-07-25\u0027), (\u00272011-10-28\u0027)),\nPARTITION p20111028 VALUES [(\u00272011-10-28\u0027), (\u00272012-01-31\u0027)),\nPARTITION p20120131 VALUES [(\u00272012-01-31\u0027), (\u00272012-05-05\u0027)),\nPARTITION p20120505 VALUES [(\u00272012-05-05\u0027), (\u00272012-08-08\u0027)),\nPARTITION p20120808 VALUES [(\u00272012-08-08\u0027), (\u00272012-11-11\u0027)),\nPARTITION p20121111 VALUES [(\u00272012-11-11\u0027), (\u00272013-02-14\u0027)),\nPARTITION p20130214 VALUES [(\u00272013-02-14\u0027), (\u00272013-05-20\u0027)),\nPARTITION p20130520 VALUES [(\u00272013-05-20\u0027), (\u00272013-08-23\u0027)),\nPARTITION p20130823 VALUES [(\u00272013-08-23\u0027), (\u00272013-11-26\u0027)),\nPARTITION p20131126 VALUES [(\u00272013-11-26\u0027), (\u00272014-03-01\u0027)),\nPARTITION p20140301 VALUES [(\u00272014-03-01\u0027), (\u00272014-06-04\u0027)),\nPARTITION p20140604 VALUES [(\u00272014-06-04\u0027), (\u00272014-09-07\u0027)),\nPARTITION p20140907 VALUES [(\u00272014-09-07\u0027), (\u00272014-12-11\u0027)),\nPARTITION p20141211 VALUES [(\u00272014-12-11\u0027), (\u00272015-03-16\u0027)),\nPARTITION p20150316 VALUES [(\u00272015-03-16\u0027), (\u00272015-06-19\u0027)),\nPARTITION p20150619 VALUES [(\u00272015-06-19\u0027), (\u00272015-09-22\u0027)),\nPARTITION p20150922 VALUES [(\u00272015-09-22\u0027), (\u00272015-12-26\u0027)),\nPARTITION p20151226 VALUES [(\u00272015-12-26\u0027), (\u00272016-03-30\u0027)),\nPARTITION p20160330 VALUES [(\u00272016-03-30\u0027), (\u00272016-07-03\u0027)),\nPARTITION p20160703 VALUES [(\u00272016-07-03\u0027), (\u00272016-10-06\u0027)),\nPARTITION p20161006 VALUES [(\u00272016-10-06\u0027), (\u00272017-01-09\u0027)),\nPARTITION p20170109 VALUES [(\u00272017-01-09\u0027), (\u00272017-04-14\u0027)),\nPARTITION p20170414 VALUES [(\u00272017-04-14\u0027), (\u00272017-07-18\u0027)),\nPARTITION p20170718 VALUES [(\u00272017-07-18\u0027), (\u00272017-10-21\u0027)),\nPARTITION p20171021 VALUES [(\u00272017-10-21\u0027), (\u00272018-01-24\u0027)),\nPARTITION p20180124 VALUES [(\u00272018-01-24\u0027), (\u00272018-04-29\u0027)),\nPARTITION p20180429 VALUES [(\u00272018-04-29\u0027), (\u00272018-08-02\u0027)),\nPARTITION p20180802 VALUES [(\u00272018-08-02\u0027), (\u00272018-11-05\u0027)),\nPARTITION p20181105 VALUES [(\u00272018-11-05\u0027), (\u00272019-02-08\u0027)),\nPARTITION p20190208 VALUES [(\u00272019-02-08\u0027), (\u00272019-05-14\u0027)),\nPARTITION p20190514 VALUES [(\u00272019-05-14\u0027), (\u00272019-08-17\u0027)),\nPARTITION p20190817 VALUES [(\u00272019-08-17\u0027), (\u00272019-11-20\u0027)),\nPARTITION p20191120 VALUES [(\u00272019-11-20\u0027), (\u00272020-02-23\u0027)),\nPARTITION p20200223 VALUES [(\u00272020-02-23\u0027), (\u00272020-05-28\u0027)),\nPARTITION p20200528 VALUES [(\u00272020-05-28\u0027), (\u00272020-08-31\u0027)),\nPARTITION p20200831 VALUES [(\u00272020-08-31\u0027), (\u00272020-12-04\u0027)),\nPARTITION p20201204 VALUES [(\u00272020-12-04\u0027), (\u00272021-03-09\u0027)),\nPARTITION p20210309 VALUES [(\u00272021-03-09\u0027), (\u00272021-06-12\u0027)),\nPARTITION p20210612 VALUES [(\u00272021-06-12\u0027), (\u00272021-09-15\u0027)),\nPARTITION p20210915 VALUES [(\u00272021-09-15\u0027), (\u00272021-12-19\u0027)),\nPARTITION p20211219 VALUES [(\u00272021-12-19\u0027), (\u00272022-03-24\u0027)))\nDISTRIBUTED BY HASH(`c_0_3`, `c_0_5`, `c_0_4`, `c_0_1`, `c_0_0`, `c_0_2`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"bloom_filter_columns\" \u003d \"c_0_5\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "v0.t1":"CREATE TABLE `t1` (\n  `c_1_0` datetime NULL COMMENT \"\",\n  `c_1_1` decimal64(6, 3) SUM NULL COMMENT \"\",\n  `c_1_2` decimal128(31, 15) SUM NULL COMMENT \"\",\n  `c_1_3` hll HLL_UNION NULL COMMENT \"\",\n  `c_1_4` int(11) SUM NULL COMMENT \"\",\n  `c_1_5` decimal128(28, 16) REPLACE NULL COMMENT \"\",\n  INDEX index1_c_1_0 (`c_1_0`) USING BITMAP\n) ENGINE\u003dOLAP \nAGGREGATE KEY(`c_1_0`)\nCOMMENT \"OLAP\"\nPARTITION BY RANGE(`c_1_0`)\n(PARTITION p20100101 VALUES [(\u00272010-01-01 00:00:00\u0027), (\u00272010-07-19 00:00:00\u0027)),\nPARTITION p20100719 VALUES [(\u00272010-07-19 00:00:00\u0027), (\u00272011-02-03 00:00:00\u0027)),\nPARTITION p20110203 VALUES [(\u00272011-02-03 00:00:00\u0027), (\u00272011-08-21 00:00:00\u0027)),\nPARTITION p20110821 VALUES [(\u00272011-08-21 00:00:00\u0027), (\u00272012-03-07 00:00:00\u0027)),\nPARTITION p20120307 VALUES [(\u00272012-03-07 00:00:00\u0027), (\u00272012-09-22 00:00:00\u0027)),\nPARTITION p20120922 VALUES [(\u00272012-09-22 00:00:00\u0027), (\u00272013-04-09 00:00:00\u0027)),\nPARTITION p20130409 VALUES [(\u00272013-04-09 00:00:00\u0027), (\u00272013-10-25 00:00:00\u0027)),\nPARTITION p20131025 VALUES [(\u00272013-10-25 00:00:00\u0027), (\u00272014-05-12 00:00:00\u0027)),\nPARTITION p20140512 VALUES [(\u00272014-05-12 00:00:00\u0027), (\u00272014-11-27 00:00:00\u0027)),\nPARTITION p20141127 VALUES [(\u00272014-11-27 00:00:00\u0027), (\u00272015-06-14 00:00:00\u0027)),\nPARTITION p20150614 VALUES [(\u00272015-06-14 00:00:00\u0027), (\u00272015-12-30 00:00:00\u0027)),\nPARTITION p20151230 VALUES [(\u00272015-12-30 00:00:00\u0027), (\u00272016-07-16 00:00:00\u0027)),\nPARTITION p20160716 VALUES [(\u00272016-07-16 00:00:00\u0027), (\u00272017-01-31 00:00:00\u0027)),\nPARTITION p20170131 VALUES [(\u00272017-01-31 00:00:00\u0027), (\u00272017-08-18 00:00:00\u0027)),\nPARTITION p20170818 VALUES [(\u00272017-08-18 00:00:00\u0027), (\u00272018-03-05 00:00:00\u0027)),\nPARTITION p20180305 VALUES [(\u00272018-03-05 00:00:00\u0027), (\u00272018-09-20 00:00:00\u0027)),\nPARTITION p20180920 VALUES [(\u00272018-09-20 00:00:00\u0027), (\u00272019-04-07 00:00:00\u0027)),\nPARTITION p20190407 VALUES [(\u00272019-04-07 00:00:00\u0027), (\u00272019-10-23 00:00:00\u0027)),\nPARTITION p20191023 VALUES [(\u00272019-10-23 00:00:00\u0027), (\u00272020-05-09 00:00:00\u0027)),\nPARTITION p20200509 VALUES [(\u00272020-05-09 00:00:00\u0027), (\u00272020-11-24 00:00:00\u0027)),\nPARTITION p20201124 VALUES [(\u00272020-11-24 00:00:00\u0027), (\u00272021-06-11 00:00:00\u0027)),\nPARTITION p20210611 VALUES [(\u00272021-06-11 00:00:00\u0027), (\u00272021-12-27 00:00:00\u0027)),\nPARTITION p20211227 VALUES [(\u00272021-12-27 00:00:00\u0027), (\u00272022-07-14 00:00:00\u0027)))\nDISTRIBUTED BY HASH(`c_1_0`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);"
  },
  "table_row_count":{
    "v0.t1":{
      "p20100101":3
    },
    "v0.t0":{
      "p20100101":7
    }
  },
  "view_meta":{
    "v0.v5":"SELECT `t1_8`.`c_1_0` AS `c_1_0` FROM `v0`.`t1` AS `t1_8` FULL OUTER JOIN `v0`.`t0` AS `t0_7` ON (((((`t1_8`.`c_1_4` \u003d `t0_7`.`c_0_2`) AND (-466695339 \u003d (`t0_7`.`c_0_6` BETWEEN `t0_7`.`c_0_6` AND `t0_7`.`c_0_6`))) AND (`t1_8`.`c_1_1` \u003e\u003d `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_1` \u003e `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_4` \u003e `t0_7`.`c_0_4`)) AND (`t1_8`.`c_1_4` \u003e\u003d `t0_7`.`c_0_4`) WHERE FALSE UNION ALL SELECT `t1_8`.`c_1_0` AS `c_1_0` FROM `v0`.`t1` AS `t1_8` FULL OUTER JOIN `v0`.`t0` AS `t0_7` ON (((((`t1_8`.`c_1_4` \u003d `t0_7`.`c_0_2`) AND (-466695339 \u003d (`t0_7`.`c_0_6` BETWEEN `t0_7`.`c_0_6` AND `t0_7`.`c_0_6`))) AND (`t1_8`.`c_1_1` \u003e\u003d `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_1` \u003e `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_4` \u003e `t0_7`.`c_0_4`)) AND (`t1_8`.`c_1_4` \u003e\u003d `t0_7`.`c_0_4`) WHERE NOT FALSE UNION ALL SELECT `t1_8`.`c_1_0` AS `c_1_0` FROM `v0`.`t1` AS `t1_8` FULL OUTER JOIN `v0`.`t0` AS `t0_7` ON (((((`t1_8`.`c_1_4` \u003d `t0_7`.`c_0_2`) AND (-466695339 \u003d (`t0_7`.`c_0_6` BETWEEN `t0_7`.`c_0_6` AND `t0_7`.`c_0_6`))) AND (`t1_8`.`c_1_1` \u003e\u003d `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_1` \u003e `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_4` \u003e `t0_7`.`c_0_4`)) AND (`t1_8`.`c_1_4` \u003e\u003d `t0_7`.`c_0_4`) WHERE FALSE IS NULL",
    "v0.v1":"SELECT `t1_8`.`c_1_0` AS `c_1_0` FROM `v0`.`t1` AS `t1_8` FULL OUTER JOIN `v0`.`t0` AS `t0_7` ON (((((`t1_8`.`c_1_4` \u003d `t0_7`.`c_0_2`) AND (-466695339 \u003d (`t0_7`.`c_0_6` BETWEEN `t0_7`.`c_0_6` AND `t0_7`.`c_0_6`))) AND (`t1_8`.`c_1_1` \u003e\u003d `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_1` \u003e `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_4` \u003e `t0_7`.`c_0_4`)) AND (`t1_8`.`c_1_4` \u003e\u003d `t0_7`.`c_0_4`)",
    "v0.v0":"SELECT `t0_2`.`c_0_0` AS `c_0_0` FROM `v0`.`t0` AS `t0_2` , `v0`.`t1` AS `t1_3` ",
    "v0.v3":"SELECT `t1_8`.`c_1_0` AS `c_1_0` FROM `v0`.`t1` AS `t1_8` FULL OUTER JOIN `v0`.`t0` AS `t0_7` ON (((((`t1_8`.`c_1_4` \u003d `t0_7`.`c_0_2`) AND (-466695339 \u003d (`t0_7`.`c_0_6` BETWEEN `t0_7`.`c_0_6` AND `t0_7`.`c_0_6`))) AND (`t1_8`.`c_1_1` \u003e\u003d `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_1` \u003e `t0_7`.`c_0_11`)) AND (`t1_8`.`c_1_4` \u003e `t0_7`.`c_0_4`)) AND (`t1_8`.`c_1_4` \u003e\u003d `t0_7`.`c_0_4`) WHERE NOT FALSE",
    "v0.v11":"SELECT `t0_82`.`c_0_0` AS `c_0_0` FROM `v0`.`t0` AS `t0_82` , `v0`.`v5` AS `v5_90`  , `v0`.`v1` AS `v1_85`  , `v0`.`v0` AS `v0_84`  , `v0`.`v3` AS `v3_88` "
  },
  "session_variables":"{\"enable_resource_group\":false,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"enable_show_all_variables\":false,\"query_mem_limit\":0,\"cbo_cte_reuse\":true,\"enable_tablet_internal_parallel\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"join_implementation_mode\":\"hash\",\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"auto_increment_increment\":1,\"sql_mode_v2\":8589934592,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"character_set_results\":\"utf8\",\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"forward_to_master\":false,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"new_planner_optimize_timeout\":3000,\"force_schedule_local\":false,\"pipeline_dop\":0,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"single_node_exec_plan\":false,\"load_mem_limit\":0,\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"statistic_collect_parallel\":1,\"sql_safe_updates\":0,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"global_runtime_filter_probe_min_size\":102400,\"enable_exchange_pass_through_expire\":false,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"new_planner_agg_stage\":0,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"exec_mem_limit\":2147483648,\"cbo_max_reorder_node_use_dp\":10,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"max_allowed_packet\":1048576,\"query_timeout\":60,\"cbo_max_reorder_node\":50,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"character_set_server\":\"utf8\",\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"disable_streaming_preaggregations\":false,\"allow_default_partition\":false}",
  "column_statistics":{
    "v0.t1":{
      "c_1_4":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_1_1":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_1_0":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "v0.t0":{
      "c_0_6":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_0_4":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_0_2":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_0_0":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_0_11":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    }
  },
  "be_number":2,
  "exception":[

  ],
  "version":"UNKNOWN",
  "commit_version":"2474d75f1"
}